Create Table Beauty.BeautyInfo
(
 Beauty_InfoID int identity(1,1) primary key,
 BeautyProductType_InfoID int not null,
 BatteryTypeLithiumIon int ,
 BatteryTypeLithiumMetal int ,
 LithiumBatteryEnergyContent int,
 LithiumBatteryPackaging nvarchar(33),
 LithiumBatteryVoltage decimal(18,2),
 LithiumBatteryWeight decimal(18,2),
 MedicineClassification varchar(50),
 NumberOfLithiumIonCells int ,
 NumberOfLithiumMetalCells int ,
 PlugType varchar(50),
 SpecificUsesForProduct1 varchar(50) not null,
 SpecificUsesForProduct2 varchar(50) not null,
 Certification1 varchar(50) not null,
 Certification2 varchar(50) not null,
 SunProtection_VoltageDecimal_Wattage_InfoID int ,
 IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime DATETIME DEFAULT GETDATE(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate() 
)
Create Table Beauty.SunProtection_VoltageDecimal_WattageInfo
(
SunProtection_VoltageDecimal_Wattage_InfoID int identity(1,1) primary key,
SunProtectionUnitOfMeasure nvarchar(22) default 'sun_protection_factor',
SunProtectionValue int,
VoltageUnitOfMeasure nvarchar(11),
VoltageValue decimal(18,2),
WattageUnitOfMeasure nvarchar(10),
Wattage decimal(18,2),
IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime DATETIME DEFAULT GETDATE(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate()
)


Create Table Beauty.BeautyProductTypeInfo
(
BeautyProductType_InfoID int identity(1,1) primary key,
ItemObject NVARCHAR(50)NOT NULL,
ItemID int not null,
IsDel bit default 0,
CreateUser nvarchar(20) default 'PU',
CreateTime DATETIME DEFAULT GETDATE(),
UpdateUser nvarchar(20) default 'FL',
UpdateTime datetime default getdate()
)